Skip to content
Discussions
Topics
Support
Product Ideas
Help & Learning
Sign in
Try Smartsheet
Laurie Olson
Laurie Olson
Home
›
Laurie Olson
›
Awesome
Laurie Olson
·
Senior Program Manager
·
✭✭✭✭
Overview
Overview
Email
laurie.olson@nationaldentex.com
Roles
Member
Badges
10
About Me
About Me
Analytics
18
Posts
132
Visits
374
Points
Nov 10, 2021
Join Date
Apr 1, 2025
Last Active
Reactions
Insightful 4
4
Vote Up 1
1
Awesome 1
1
Activity
Posts
Comments
18
Re: Formula Help - if cell = X then show network days
Laurie Olson
03/21/25
Give this a try: =IF([Date Closed]@row <> "", NETWORKDAY([Date Open]@row, [Date Closed]@row), NETWORKDAY([Date Open]@row, TODAY(0)))
1
·
Activity
Posts
Comments
18
Badges